﻿CREATE PROCEDURE [ServiceMemberManagement].[GetAllTypesOfMilitaryBranch]

AS 

---------------------------------------------------------------------------------------------------
--						Liberty
---------------------------------------------------------------------------------------------------
--  Stored Procedure :: GetAllTypesOfMilitaryBranch
--                                                                            
---------------------------------------------------------------------------------------------------

SET NOCOUNT ON 

SELECT 	OID,
        Version,
		Branch as 'Description',
		Active,
		DisplayOrder,
		CreatedDate
FROM dbo.TypesOfMilitaryBranch
WHERE Active = 1        
ORDER BY DisplayOrder


